ClassSection

EntityType | Independent
Logical Entity Name | ClassSection
Default Table Name | AdClassSched
Logical Only | NO
Owner | dbo
Definition |
Note |

ClassSection Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
CourseCode |  | CHAR(12) | NO |
SectionCode |  | VARCHAR(8) | NO |
SectionName |  | VARCHAR(75) | NO |
CampusId |  | INTEGER | NO |
MaximumStudents |  | INTEGER | NO |
NumberRegisteredStudents |  | INTEGER | NO |
InstructorId |  | INTEGER | NO |
CourseId |  | INTEGER | YES |
ClassSectionId |  | INTEGER | NO |
PostAttendanceType |  | CHAR(1) | YES |
AttendanceLastPostedDate |  | DATETIME | YES |
NextAttendanceDate |  | DATETIME | YES |
StartDate |  | DATETIME | YES |
EndDate |  | DATETIME | YES |
ModFlag |  | CHAR(1) | NO |
IsActive |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
Note |  | VARCHAR(4000) | YES |
IsMeetingOnIrregularDaysTimes |  | BIT | YES |
AutoDropPercentageHoursAbsent |  | NUMERIC(5, 2) | YES |
AutoDropConsecutiveHoursAbsent |  | NUMERIC(6, 0) | YES |
AutoDropCumulativeHoursAbsent |  | NUMERIC(6, 0) | YES |
AutoWarningPercentageHoursAbsent |  | NUMERIC(5, 2) | YES |
AutoWarningConsecutiveHoursAbsent |  | NUMERIC(6, 0) | YES |
AutoWarningCumulativeHoursAbsent |  | NUMERIC(6, 0) | YES |
MakeUpMaxType |  | CHAR(1) | YES |
MakeUpMaxValue |  | NUMERIC(7, 2) | YES |
IsWaitlistExpiredOrCleared |  | BIT | NO |
StartTime |  | DATETIME | YES |
DaysFlag |  | INTEGER | NO |
SyllabusDocument |  | VARCHAR(255) | YES |
FinalCountRegisteredStudents |  | INTEGER | NO |
FinalCountDropStudents |  | INTEGER | NO |
IsWaitListingAllowed |  | BIT | NO |
WaitListMaximumSeats |  | INTEGER | NO |
AllowReservations |  | BIT | NO |
DeliveryMethodId |  | INTEGER | YES |
HideFaculty |  | BIT | NO |
HideLocation |  | BIT | NO |
IsBlindGrading |  | BIT | NO |
SendToLMS |  | BIT | NO |
IsAuditAdvisementRequired |  | BIT | YES |
ShiftId |  | INTEGER | YES |
PassFailSetting |  | TINYINT | NO |
StudentSpecificMeetingScheduleDefaultMinutes |  | INTEGER | NO |
IsStudentSpecificMeetingSchedule |  | BIT | NO |
AddedClassSectionId |  | INTEGER | NO |
ThresholdType |  | BIT | YES |
ThresholdNumberOfSeats |  | SMALLINT | YES |
LmsVendorId |  | INTEGER | YES |
LmsExtractStatus |  | CHAR(1) | YES |
ClassSchedLength |  | INTEGER | YES |
MaxNumberSectionsAllowed |  | INTEGER | NO |
IsClassSectionAutoAdded |  | BIT | NO |
EnrollmentStatusCreditHours |  | MONEY(19, 4) | NO |
EnrollmentStatusClockHours |  | MONEY(19, 4) | NO |
AddDropDate |  | DATETIME | YES |
IsAddDropDateOverride |  | BIT | NO |
LastDayToWithdrawDate |  | DATETIME | YES |
IsLdwOverride |  | BIT | NO |
IsAutoDropEnforcedAfterLdw |  | BIT | NO |
IsAutoWarningOnClassRosterAfterLdw |  | BIT | NO |
CreditHours |  | MONEY(19, 4) | YES |
ClockHours |  | MONEY(19, 4) | YES |
AllowCreditsHoursOverride |  | BIT | NO |
MinimumCredits |  | MONEY(19, 4) | YES |
MaximumCredits |  | MONEY(19, 4) | YES |

ClassSection Keys

Key Name | Key Type | Keys
AdClassSched_SyLmsVendorID_N_N_IDX | Inversion Entry | LmsVendorId
AdClassSched_AdShiftID_N_N_IDX | Inversion Entry | ShiftId
AdCLassSched_Code_Section_N_N_IDX | Inversion Entry | CourseCode, SectionCode
AdClassSched_StartDate_N_N_IDX | Inversion Entry | StartDate
AdClassSched_Active_AdCourseID_SyCampusID_N_N_IDX | Inversion Entry | IsActive, InstructorId, CampusId
AdClassSched_AdTeacherID_N_N_IDX | Inversion Entry | InstructorId
AdClassSched_AdCourseID_StartDate_EndDate_AdClassSchedId_U_N_IDX | Alternate Key | StartDate, EndDate, InstructorId
AdClassSched_SyCmpsID_AdClssSchdId_AdCrsId_Dscrp_Cd_DsFlg_StrtTm_AdTchrID_AdDelivMethId_Sctn_HdFac_HdLoc_MxStd_RgStd_Act_U_N_IDX | Alternate Key | CampusId, InstructorId, SectionName, CourseCode, DaysFlag, StartTime, DeliveryMethodId, SectionCode, HideFaculty, HideLocation, MaximumStudents, NumberRegisteredStudents, IsActive
AdClassSched_AdCourseID_Active_N_N_IDX | Inversion Entry | InstructorId, IsActive
AdClassSched_AdClassSchedID_U_C_IDX | PrimaryKey | ClassSectionId

ClassSection Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Instructor | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
Course | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseId | NO
DeliveryMethod | Non-Identifying | Zero or One to Zero or More |  |  |  | DeliveryMethodId | NO
Shift | Non-Identifying | Zero or One to Zero or More |  |  |  | ShiftId | NO
LmsVendor | Non-Identifying | Zero or One to Zero or More |  |  |  | LmsVendorId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
RegistrationTrackClassSection | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionRequiredDocument | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionMeetingDate | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionLesson | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionMeetingSchedule | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionBook | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionFeeSchedule | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionLesson | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionMeetingPattern | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionMeetingSchedule | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionRequiredDocument | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionSecondaryInstructor | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
CrossListClassSection | Non-Identifying | One To Zero or More |  |  |  |  | NO
DeliveryMethod | Non-Identifying | One To Zero or More |  |  |  |  | NO
Instructor | Non-Identifying | One To Zero or More |  |  |  |  | NO
RegistrationTrackClassSection | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransactionRegisteredClass | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseDocumentPermit | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCoursePendingRegistration | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStatusChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
Task | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionFeeSchedule | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionBook | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionCrossRegistrationGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
ClassSectionSecondaryInstructor | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdClassSchedInstructorAttributes | Non-Identifying | One To Zero or More |  |  |  |  | NO
CrossListClassSection | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCoursePendingRegistration | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdLessonPlanCourseMap | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseDocumentPermit | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRevenueSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaTransCourseAmount | Non-Identifying | One To Zero or More |  |  |  |  | NO

ClassSection Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdClassSched_MakeUpMaxNum | ([MakeUpMaxType] = 'P' and ([MakeUpMaxNum] >= 0 and [MakeUpMaxNum] <= 100) or [MakeUpMaxType] = 'H' or [MakeUpMaxType] = null and [MakeUpMaxNum] = null)

ClassSection Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ClassSection | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdClassSched | NO |  |  |

ClassSection Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Logical | CourseRegistration
Logical | Documents
Logical | LedgerCard_Billing
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

ClassSection Data Movement Rules

Name | Type | Rule Text/Value